package com.example.shardingsheredemo.mapper;

import com.example.shardingsheredemo.entity.TbDeviceInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 13057
* @description 针对表【tb_device_info】的数据库操作Mapper
* @createDate 2022-09-21 20:19:12
* @Entity com.example.shardingsheredemo.entity.TbDeviceInfo
*/
public interface TbDeviceInfoMapper extends BaseMapper<TbDeviceInfo> {

    @Select(value = "select a.id, a.device_id, device_intro, device_type from tb_device_info a left join tb_device b on a.device_id =  b.device_id")
    public List<TbDeviceInfo> queryDeviceInfo();

}




